<!DOCTYPE html>
<html>
<head><meta name="generator" content="Hexo 3.8.0">
  <meta charset="utf-8">
  
  
  <meta name="description" content="0.前言Sakila 可以作为数据库设计的参考，也可作为实验数据。本例是用作数据分析学习的实验数据。

The Sakila sample database was developed by Mike Hillyer, a former member of the MySQL AB document">
  

  
  
  
  
  
  
  <title>Sakila MySQL 样例数据库解析 | Suwen</title>
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
  <meta name="description" content="0.前言Sakila 可以作为数据库设计的参考，也可作为实验数据。本例是用作数据分析学习的实验数据。  The Sakila sample database was developed by Mike Hillyer, a former member of the MySQL AB documentation team, and is intended to provide a standard">
<meta name="keywords" content="mysql">
<meta property="og:type" content="article">
<meta property="og:title" content="Sakila MySQL 样例数据库解析">
<meta property="og:url" content="http://yoursite.com/2019/06/02/sakila-database/index.html">
<meta property="og:site_name" content="Suwen">
<meta property="og:description" content="0.前言Sakila 可以作为数据库设计的参考，也可作为实验数据。本例是用作数据分析学习的实验数据。  The Sakila sample database was developed by Mike Hillyer, a former member of the MySQL AB documentation team, and is intended to provide a standard">
<meta property="og:locale" content="CHS">
<meta property="og:image" content="http://yoursite.com/2019/06/02/sakila-database/1.png">
<meta property="og:image" content="http://yoursite.com/2019/06/02/sakila-database/2.png">
<meta property="og:image" content="http://yoursite.com/2019/06/02/sakila-database/3.png">
<meta property="og:image" content="http://yoursite.com/2019/06/02/sakila-database/4.png">
<meta property="og:image" content="http://yoursite.com/2019/06/02/sakila-database/5.png">
<meta property="og:image" content="http://yoursite.com/2019/06/02/sakila-database/6.png">
<meta property="og:image" content="http://yoursite.com/2019/06/02/sakila-database/7.png">
<meta property="og:image" content="http://yoursite.com/2019/06/02/sakila-database/8.png">
<meta property="og:image" content="http://yoursite.com/2019/06/02/sakila-database/9.png">
<meta property="og:image" content="http://yoursite.com/2019/06/02/sakila-database/10.png">
<meta property="og:image" content="http://yoursite.com/2019/06/02/sakila-database/11.png">
<meta property="og:updated_time" content="2019-06-02T09:27:39.000Z">
<meta name="twitter:card" content="summary">
<meta name="twitter:title" content="Sakila MySQL 样例数据库解析">
<meta name="twitter:description" content="0.前言Sakila 可以作为数据库设计的参考，也可作为实验数据。本例是用作数据分析学习的实验数据。  The Sakila sample database was developed by Mike Hillyer, a former member of the MySQL AB documentation team, and is intended to provide a standard">
<meta name="twitter:image" content="http://yoursite.com/2019/06/02/sakila-database/1.png">
  
  
    <link rel="icon" href="/css/images/favicon.ico">
  
  <link rel="stylesheet" href="/css/style.css">
  

  
  <!-- baidu webmaster push -->
  <script src="//push.zhanzhang.baidu.com/push.js"></script>
</head></html>
<body class="home blog custom-background custom-font-enabled single-author">
  <div id="page" class="hfeed site">
      <header id="masthead" class="site-header" role="banner">
    <hgroup>
      <h1 class="site-title">
        <a href="/" title="Suwen" rel="home">Suwen</a>
      </h1>
      
        <h2 class="site-description">
          <a href="/" id="subtitle">never settle</a>
        </h2>
      
    </hgroup>

    <nav id="site-navigation" class="main-navigation" role="navigation">
            <button class="menu-toggle">菜单</button>
            <a class="assistive-text" href="/#content" title="跳至内容">跳至内容</a><!--TODO-->
            <div class="menu-main-container">
                <ul id="menu-main" class="nav-menu">
                
                    <li class="menu-item menu-item-type-post_type menu-item-object-page"><a href="/">Home</a></li>
                
                    <li class="menu-item menu-item-type-post_type menu-item-object-page"><a href="/archives">Archives</a></li>
                
                    <li class="menu-item menu-item-type-post_type menu-item-object-page"><a href="/shigure">Shigure</a></li>
                
                </ul>
            </div>
    </nav>
</header>

      <div id="main" class="wrapper">
        <div id="primary" class="site-content"><div id="content" role="main"><article id="post-sakila-database" class="post-sakila-database post type-post status-publish format-standard hentry">
    <!---->

      <header class="entry-header">
        
        
  
    <h1 class="entry-title article-title">
      Sakila MySQL 样例数据库解析
    </h1>
  

        
        <div class="comments-link">
            
            <a href="javascript:void(0);" data-url="http://yoursite.com/2019/06/02/sakila-database/" data-id="ck2tq8usx000vsj77luxjn0qr" class="leave-reply bdsharebuttonbox" data-cmd="more">Share</a>
        </div><!-- .comments-link -->
      </header><!-- .entry-header -->

    <div class="entry-content">
      
        <h1 id="0-前言"><a href="#0-前言" class="headerlink" title="0.前言"></a>0.前言</h1><p>Sakila 可以作为数据库设计的参考，也可作为实验数据。本例是用作数据分析学习的实验数据。</p>
<blockquote>
<p>The Sakila sample database was developed by Mike Hillyer, a former member of the MySQL AB documentation team, and is intended to provide a standard schema that can be used for examples in books, tutorials, articles, samples, and so forth. Sakila sample database also serves to highlight the latest features of MySQL such as Views, Stored Procedures, and Triggers.</p>
</blockquote>
<h1 id="1-实验环境"><a href="#1-实验环境" class="headerlink" title="1.实验环境"></a>1.实验环境</h1><h3 id="方法一：安装-MySQL-时选择-FULL-完全安装"><a href="#方法一：安装-MySQL-时选择-FULL-完全安装" class="headerlink" title="方法一：安装 MySQL 时选择 FULL 完全安装"></a>方法一：安装 MySQL 时选择 FULL 完全安装</h3><p>安装 MySQL 时选择 FULL 完全安装，默认安装了 Sakila sample database<br><img src="/2019/06/02/sakila-database/1.png" alt="1"></p>
<h3 id="方法二：下载后导入"><a href="#方法二：下载后导入" class="headerlink" title="方法二：下载后导入"></a>方法二：下载后导入</h3><p>下载地址：</p>
<ul>
<li><a href="http://downloads.mysql.com/docs/sakila-db.zip" target="_blank" rel="noopener">ZIP 格式</a></li>
<li><a href="http://downloads.mysql.com/docs/sakila-db.tar.gz" target="_blank" rel="noopener">tar 格式</a></li>
<li><a href="http://dev.mysql.com/doc/sakila/en/index.html" target="_blank" rel="noopener">官方文档</a></li>
</ul>
<p>解压后得到三个文件：</p>
<ol>
<li>sakila-schema.sql 文件包含创建 Sakila 数据库的结构：表、视图、存储过程和触发器</li>
<li>sakila-data.sql 文件包含：使用 INSERT 语句填充数据及在初始数据加载后，必须创建的触发器的定义</li>
<li>sakila.mwb 文件是一个 MySQL Workbench 数据模型，可以在 MySQL 的工作台打开查看数据库结构。</li>
</ol>
<blockquote>
<p>导入参考： <a href="http://dev.mysql.com/doc/sakila/en/sakila-installation.html" target="_blank" rel="noopener">http://dev.mysql.com/doc/sakila/en/sakila-installation.html</a></p>
</blockquote>
<pre><code>shell&gt; mysql -u root -p
mysql&gt; SOURCE C:/temp/sakila-db/sakila-schema.sql;
mysql&gt; SOURCE C:/temp/sakila-db/sakila-data.sql;
</code></pre><h1 id="2-数据结构"><a href="#2-数据结构" class="headerlink" title="2.数据结构"></a>2.数据结构</h1><p>Sakila 样例数据库包括 16 张表格，7 个视图，3 个 Stored Procedures，3 个 Functions，6 个 Triggers。英文描述点开相应连接即可查看。<br>总览：<br><img src="/2019/06/02/sakila-database/2.png" alt="2"><br>关系图:<br><img src="/2019/06/02/sakila-database/3.png" alt="3"></p>
<h1 id="3-视图"><a href="#3-视图" class="headerlink" title="3.视图"></a>3.视图</h1><p>actor_info 视图提供了所有演员的列表及所演的电影，电影按 category 分组.<br>actor → film_actor → film →  film_category → category</p>
<ol>
<li>actor_id: 代理主键用于唯一标识表中的每个演员</li>
<li>first_name: 演员的名字</li>
<li>last_name: 演员的姓氏</li>
<li>last_update: 该行已创建或最近更新的时间</li>
</ol>
<p><img src="/2019/06/02/sakila-database/4.png" alt="4"></p>
<p>客户列表，firstname和lastname连接成fullname，将 address, city, country 集成在一个视图里<br>customer → address → city → country</p>
<ol>
<li>stomer_id: 代理主键用于唯一标识表中的每个客户</li>
<li>store_id: 一个外键，确定客户所属的 store。</li>
<li>first_name: 客户的名字</li>
<li>last_name: 客户的姓氏</li>
<li>email: 客户的电子邮件地址</li>
<li>address_id: 使用在地址 表的外键来确定客户的地址</li>
<li>active: 表示客户是否是活跃的客户</li>
<li>create_date: 顾客被添加到系统中的日期。使用 INSERT 触发器自动设置。</li>
<li>last_update: 该行已创建或最近更新的时间</li>
</ol>
<p><img src="/2019/06/02/sakila-database/5.png" alt="5"></p>
<p>每个电影种类的销售额<br>payment → rental → inventory → film → film_category → category</p>
<p><img src="/2019/06/02/sakila-database/6.png" alt="6"></p>
<p>每个商店的 manager 及销售额。<br>payment → rental → inventory → store → staff</p>
<p>store 表列出了系统中的所有商店 。<br>store 使用外键来标识工作人员和地址；在员工、客户、库存表被作为外键使用。</p>
<ol>
<li>store_id: 代理主键唯一标识的商店</li>
<li>manager_staff_id: 使用外键来标识这家商店的经理</li>
<li>address_id: 使用外键来确定这家店的地址</li>
<li>last_update: 该行已创建或最近更新的时间</li>
</ol>
<p><img src="/2019/06/02/sakila-database/7.png" alt="7"></p>
<p>工作人员的列表</p>
<p>工作人员表列出了所有的工作人员，包括电子邮件地址，登录信息和图片信息 。<br>工作人员表是指使用外键来标识存储和地址表；在出租、支付和商店表中作为外键。</p>
<ol>
<li>staff_id: 代理主键唯一标识的工作人员</li>
<li>first_name: 工作人员的名字</li>
<li>last_name: 工作人员的姓氏</li>
<li>address_id: 工作人员的地址在地址表的外键</li>
<li>picture: 工作人员的照片，使用了 BLOB 属性</li>
<li>email: 工作人员的电子邮件地址</li>
<li>store_id: 工作人员所在的商店，用外键标识</li>
<li>active: 是否是活跃的工作人员。</li>
<li>username: 用户名，由工作人员用来访问租赁系统</li>
<li>password: 工作人员访问租赁系统所使用的密码。使用了 SHA1 函数</li>
<li>last_update: 该行已创建或最近更新的时间</li>
<li>active: 是否有效，删除时设置为 False</li>
</ol>
<p><img src="/2019/06/02/sakila-database/8.png" alt="8"></p>
<h1 id="4-数据分析"><a href="#4-数据分析" class="headerlink" title="4.数据分析"></a>4.数据分析</h1><p><em>最具有购买潜力的顾客</em>：</p>
<p>从600位顾客中去发现和找出最具有购买潜力的顾客，找出他们的邮箱地址和联系方法，并给他们发送邮件进行感谢，以保持该部分用户的持续购买欲望，增加用户的满意度，以此来保持商品的销售量。</p>
<h3 id="0-数据获取"><a href="#0-数据获取" class="headerlink" title="0.数据获取"></a>0.数据获取</h3><p>根据customer、payment两个表进行数据筛选，获得顾客编号：customer.customer_id 顾客编号；计算总消费金额;最后根据顾客消费总金额降序排列。<br><img src="/2019/06/02/sakila-database/9.png" alt="9"><br>具体代码：<br><figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br><span class="line">10</span><br><span class="line">11</span><br><span class="line">12</span><br><span class="line">13</span><br></pre></td><td class="code"><pre><span class="line">SELECT</span><br><span class="line">  customer1.customer_id 顾客编号,</span><br><span class="line">	CONCAT( customer1.`first_name`, CONCAT( &quot; &quot;, customer1.`last_name` ) ) AS &apos;顾客名&apos;,</span><br><span class="line">	FORMAT(sum(payment.amount),2) AS &apos;消费金额&apos;</span><br><span class="line">FROM</span><br><span class="line">	customer1,</span><br><span class="line">	payment</span><br><span class="line">WHERE</span><br><span class="line">	customer1.customer_id = payment.customer_id</span><br><span class="line">GROUP BY</span><br><span class="line">	CONCAT( customer1.`first_name`, CONCAT( &quot; &quot;, customer1.`last_name` ) )</span><br><span class="line">ORDER BY</span><br><span class="line">	FORMAT(sum(payment.amount),2)+0 DESC</span><br></pre></td></tr></table></figure></p>
<h3 id="1-连接顾客姓名"><a href="#1-连接顾客姓名" class="headerlink" title="1.连接顾客姓名"></a>1.连接顾客姓名</h3><p>通过筛选address_id连接customer和address两表得到顾客的编号、地址、电话，然后通过顾客的编号升序排列。<br><img src="/2019/06/02/sakila-database/10.png" alt="10"><br>具体代码：<br><figure class="highlight plain"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br><span class="line">10</span><br><span class="line">11</span><br><span class="line">12</span><br><span class="line">13</span><br><span class="line">14</span><br><span class="line">15</span><br></pre></td><td class="code"><pre><span class="line">SELECT</span><br><span class="line">CONCAT( customer1.`first_name`, CONCAT( &quot; &quot;, customer1.`last_name` ) ) AS 顾客姓名,</span><br><span class="line">customer1.customer_id 顾客编号,</span><br><span class="line">address.address 顾客地址,</span><br><span class="line">address.phone 顾客电话,</span><br><span class="line">customer1.email</span><br><span class="line">FROM</span><br><span class="line">customer1 ,</span><br><span class="line">address</span><br><span class="line">WHERE</span><br><span class="line">	customer1.address_id=address.address_id</span><br><span class="line">GROUP BY</span><br><span class="line">	CONCAT( customer1.`first_name`, CONCAT( &quot; &quot;, customer1.`last_name` ) )</span><br><span class="line">ORDER BY</span><br><span class="line">  customer1.customer_id+0 ASC</span><br></pre></td></tr></table></figure></p>
<h3 id="2-结果分析"><a href="#2-结果分析" class="headerlink" title="2.结果分析"></a>2.结果分析</h3><p>通过表一得到散点图：</p>
<p><img src="/2019/06/02/sakila-database/11.png" alt="11"></p>
<p>根据数据分析我们可以看到顾客KARL SEAL的消费金额221.55是600位顾客中消费总金额最高的一位，他便是最有潜力的顾客，然后我们可以通过表二去得到他的联系信息。<br>通过散点图我们可以分析到大多数的顾客消费总金额分布在120元上下，所以我们以120元为界，将消费总金额在120元以上顾客列为有购买潜力的顾客，从表二寻找他们的联系方式，批量对他们发送邮件进行感谢。</p>

      
    </div><!-- .entry-content -->

    <footer class="entry-meta">
    <a href="/2019/06/02/sakila-database/">
    <time datetime="2019-06-02T08:22:59.000Z" class="entry-date">
        2019-06-02
    </time>
</a>
    
  <span class="article-delim">&#8226;</span>
  <div class="article-category">
  <a class="article-category-link" href="/categories/DATABASE/">DATABASE</a>
  </div>

    
  <span class="article-delim">&#8226;</span>
  <ul class="article-tag-list"><li class="article-tag-list-item"><a class="article-tag-list-link" href="/tags/mysql/">mysql</a></li></ul>

    </footer>
</article>


    
<nav class="nav-single">
    <h3 class="assistive-text">文章导航</h3>
    
        <span class="nav-previous"><a href="/2019/06/02/Java-MySQL/" rel="prev"><span class="meta-nav">←</span> Java MySQL 连接</a></span>
    
    
        <span class="nav-next"><a href="/2019/05/24/servlet转发/" rel="next">Servlet 的三种跳转方式 <span class="meta-nav">→</span></a></span>
    
</nav><!-- .nav-single -->







</div></div>
        <div id="secondary" class="widget-area" role="complementary">
  
    <aside class="widget">
  <h3 class="widget-title">ABOUT ME</h3>
  <div class="widget-content">
    <p>E-MAIL:esllovesn@gmail.com</p>
    <p>Github: <a href="https://github.com/EslSuwen" target="_blank">EslSuwen</a></p>
    <p>QQ：<a href="tencent://AddContact/?fromId=45&fromSubId=1&subcmd=all&uin=577014284&website=www.oicqzone.com" target="_blank">577014284</a></p>
    <a href="tencent://AddContact/?fromId=45&fromSubId=1&subcmd=all&uin=577014284&website=www.oicqzone.com" target="_blank"><img src="http://q.qlogo.cn/headimg_dl?bs=qq&dst_uin=577014284&src_uin=www.feifeiboke.com&fid=blog&spec=100" alt="hfl"></a>
    <p><strong>#全栈工程师</strong></p>
    <p>“精通 C++/Java/HTML/CSS/JS 等单词的拼写。”</p>
  </div>
</aside>
  
    
<aside class="widget">
  <h3 class="widget-title">Music</h3>
  <div class="widget-content">
    <iframe frameborder="no" border="0" marginwidth="0" marginheight="0" width="280" height="86" src="//music.163.com/outchain/player?type=2&id=101092&auto=0&height=66"></iframe>
  </div>
</aside>

  
    
  <aside class="widget">
    <h3 class="widget-title">Recents</h3>
    <div class="widget-content">
      <ul>
        
          <li>
            <a href="/2019/11/11/conceptual-model/">conceptual-model</a>
          </li>
        
          <li>
            <a href="/2019/09/01/ubuntu-install/">Windows 10 &amp; Linux 的艰难历程</a>
          </li>
        
          <li>
            <a href="/2019/06/23/2017gdp-rank/">2017 世界主要国家和地区 GDP 排名</a>
          </li>
        
          <li>
            <a href="/2019/06/09/当前云平台发展现状/">当前云平台发展现状</a>
          </li>
        
          <li>
            <a href="/2019/06/03/Java-Filter/">JavaWeb Filter 实现登录注册过滤</a>
          </li>
        
      </ul>
    </div>
  </aside>

  
    
  <aside class="widget">
    <h3 class="widget-title">Categories</h3>
    <div class="widget-content">
      <ul class="category-list"><li class="category-list-item"><a class="category-list-link" href="/categories/CODE/">CODE</a><span class="category-list-count">3</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/DATABASE/">DATABASE</a><span class="category-list-count">1</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/JAVA企业开发框架/">JAVA企业开发框架</a><span class="category-list-count">5</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/TEST/">TEST</a><span class="category-list-count">3</span></li><li class="category-list-item"><a class="category-list-link" href="/categories/TOOL/">TOOL</a><span class="category-list-count">5</span></li></ul>
    </div>
  </aside>

  
    
  <aside class="widget">
    <h3 class="widget-title">Tags</h3>
    <div class="widget-content">
      <ul class="tag-list"><li class="tag-list-item"><a class="tag-list-link" href="/tags/c/">c++</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/cloud-platforms/">cloud platforms</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/eclipse/">eclipse</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/git/">git</a><span class="tag-list-count">2</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/github/">github</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/java/">java</a><span class="tag-list-count">4</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/jsp/">jsp</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/linux/">linux</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/markdown/">markdown</a><span class="tag-list-count">2</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/mysql/">mysql</a><span class="tag-list-count">4</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/tableau/">tableau</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/test/">test</a><span class="tag-list-count">3</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/vscode/">vscode</a><span class="tag-list-count">1</span></li><li class="tag-list-item"><a class="tag-list-link" href="/tags/windows/">windows</a><span class="tag-list-count">1</span></li></ul>
    </div>
  </aside>

  
    
  <aside class="widget">
    <h3 class="widget-title">Tag Cloud</h3>
    <div class="widget-content tagcloud">
      <a href="/tags/c/" style="font-size: 10px;">c++</a> <a href="/tags/cloud-platforms/" style="font-size: 10px;">cloud platforms</a> <a href="/tags/eclipse/" style="font-size: 10px;">eclipse</a> <a href="/tags/git/" style="font-size: 13.33px;">git</a> <a href="/tags/github/" style="font-size: 10px;">github</a> <a href="/tags/java/" style="font-size: 20px;">java</a> <a href="/tags/jsp/" style="font-size: 10px;">jsp</a> <a href="/tags/linux/" style="font-size: 10px;">linux</a> <a href="/tags/markdown/" style="font-size: 13.33px;">markdown</a> <a href="/tags/mysql/" style="font-size: 20px;">mysql</a> <a href="/tags/tableau/" style="font-size: 10px;">tableau</a> <a href="/tags/test/" style="font-size: 16.67px;">test</a> <a href="/tags/vscode/" style="font-size: 10px;">vscode</a> <a href="/tags/windows/" style="font-size: 10px;">windows</a>
    </div>
  </aside>

  
    
  <aside class="widget">
    <h3 class="widget-title">Archives</h3>
    <div class="widget-content">
      <ul class="archive-list"><li class="archive-list-item"><a class="archive-list-link" href="/archives/2019/11/">November 2019</a><span class="archive-list-count">1</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2019/09/">September 2019</a><span class="archive-list-count">1</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2019/06/">June 2019</a><span class="archive-list-count">6</span></li><li class="archive-list-item"><a class="archive-list-link" href="/archives/2019/05/">May 2019</a><span class="archive-list-count">11</span></li></ul>
    </div>
  </aside>

  
    <script>
    // sub title
    var subtitleList = [
        "『卑鄙是卑鄙者的通行证，高尚是高尚者的墓志铭。』——北岛",
        "『所有模型都是错的，但其中一些是有用的。』",
        "『程序员的双手是魔术师的双手，他们把枯燥无味的代码变成了丰富多彩的软件。』——《疯狂的程序员》",
        "『质疑计算机能不能思考，就相当于质疑潜艇能不能游泳。』——Edsger Dijkstra",
        "『人们认为计算机科学是天才的艺术，但是实际情况相反，只是许多人在其它人基础上做一些东西，就像一面由石子垒成的墙。』——高德纳",
        "『Stay young. Stay simple. Always naive!』",
        "『你们媒体千万要记着，不要「见得风，是得雨」。接到消息，你们媒体本身也要判断。』——长者",
        "『假设这些完全无中生有的东西，你再帮他说一遍，你等于......你也有责任吧？』——长者",
        "『刚才你问我啊，我可以回答你一句「无可奉告」。』——长者",
        "『我告诉你们我是身经百战了，见得多了！』——长者",
        "『美国的华莱士，比你们不知要高到哪里去了，我跟他谈笑风生。』——长者",
        "『我有这个必要告诉你们一点，人生的经验。』——长者",
        "『我没有说要钦定，没有任何这个意思。』——长者",
        "『你们啊，不要想喜欢弄个大新闻，说现在已经钦定了，就把我批判一番。』——长者",
        "『一个人的命运啊，当然要靠自我奋斗，但是也要考虑历史的进程。』——长者",
        "『我说另请高明吧，我实在也不是谦虚。』——长者",
        "『苟利国家生死以，岂因祸福避趋之。』——林则徐",
        "『敢同恶鬼争高下，不向霸王让寸分。』——毛泽东",
        "『我生不为逐鹿来，都门懒筑黄金台。状元百官都如狗，总是刀下觳觫材。』——张献忠",
        "『我自成佛自度我，佛度凡尘我度佛。』",
        "『龙吟九天，一曲焚尘；苍山听雪，归时余几人。』",
        "『人最大的痛苦就是说一些自己都不相信的话。』",
        "『燃琴为薪，铸银矢以射白羽；斑音成竹，裁短笛而驭青龙。』",
        "『我们在人生的每个阶段，能影响多少人，就影响多少人，哪怕只能影响一个人，也好过不影响。——罗永浩",
        "『每个人心中都有一个死小孩。』——《龙族II》",
        "『前面是山，我们就爬山；前面是海，我们就渡海；前面是皇宫，我们就开炮！』——《龙族前传》",
        "『不要习惯了黑暗就为黑暗辩护；不要为自己的苟且而得意；不要嘲讽那些比自己更勇敢热情的人们。我们可以卑微如尘土，不可扭曲如蛆虫。』——季业",
        "『若无力驾驭，自由便是负担。",
        "『若能避开猛烈的狂喜，自然不会有悲痛来袭。』  ——太宰治 《人间失格》",


    ];

    document.addEventListener('DOMContentLoaded', evt => {
        var i = Math.floor(Math.random() * subtitleList.length);
        document.querySelector('#subtitle').innerText = subtitleList[i];
    });

    //Kill XP and IE8
    (function(){
        var ua = navigator.userAgent;
        var res = /Windows NT (\d+\.\d+)/.exec(ua);
        var xpOrLower = res && JSON.parse(res[1]) < 6;
        res = /MSIE (\d+\.\d+)/.exec(ua);
        var ie8OrLower = res && JSON.parse(res[1]) < 9;
        if(xpOrLower || ie8OrLower) {
            alert('请不要用XP及之前的Windows系统，和IE8及之前的IE浏览器访问本站！');
            location.href = "about:blank";
        }
        var fromBaiduSE = /^https?:\/\/www.baidu.com/.test(document.referrer);
        if(fromBaiduSE) {
            alert('检测到你还在使用百度搜索，作为一个程序员，这是一种自暴自弃！\n\n做不作恶的程序员，从不用百度开始！');
            location.href = "about:blank";
        }
    })();
</script>
  
</div>
      </div>
      <footer id="colophon" role="contentinfo">
    <p>&copy; 2019 Suwen
    All rights reserved.</p>
    <p>Powered by <a href="http://hexo.io/" target="_blank">Hexo</a></p>
</footer>
    <script>window._bd_share_config={"common":{"bdSnsKey":{},"bdText":"","bdMini":"1","bdMiniList":false,"bdPic":"","bdStyle":"2","bdSize":"16"},"share":{}};with(document)0[(getElementsByTagName('head')[0]||body).appendChild(createElement('script')).src='/js/share.js'];</script>

<script src="/js/jquery-3.3.1.min.js"></script>


  <link rel="stylesheet" href="/fancybox/jquery.fancybox.css">
  <script src="/fancybox/jquery.fancybox.pack.js"></script>


<script src="/js/script.js"></script>

<script src="/js/navigation.js"></script>

<div id="bg"></div>

  </div>
<script src="/live2dw/lib/L2Dwidget.min.js?094cbace49a39548bed64abff5988b05"></script><script>L2Dwidget.init({"pluginRootPath":"live2dw/","pluginJsPath":"lib/","pluginModelPath":"assets/","tagMode":false,"debug":false,"model":{"jsonPath":"/live2dw/assets/assets/tororo.model.json"},"display":{"position":"right","width":250,"height":400},"mobile":{"show":true},"log":false});</script></body>
</html>